package com.example.crt_dispatching_center.mapper;

import com.example.crt_dispatching_center.entity.ElectricityCost;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface CostMapper {
    @Select("SELECT * FROM electricity_cost WHERE date BETWEEN #{startDate} AND #{endDate}")
    List<ElectricityCost> findByDateBetween(LocalDate startDate, LocalDate endDate);
}